Release 10.1A: OpenEdge Development:
Progress Dynamics Basic Development

Creating data security allocations

If you have defined data security structures, you can assign allocations to them.

To allocate security at the level of one or more records:

Expand the Security allocation node and select Data, as shown:



At the top of the panel, select Users and Groups, Users Only, or Groups Only.
Either specify a user or group in the Name fill-in or select the All... check box just above the Name fill-in.
Note: If you want this allocation to apply only within a specific login company, choose the appropriate company from the Login company list.
Specify the name of the Entity (the dumpname of the table).
Click Refresh to see a list of records from the entity. If you specified a user or group name, a list of groups directly linked to the specified user or group also appears.
In the following example, you see records from the Customer table of the DynSports database:



Note: If you have an extensive list, you can improve performance by setting Rows to batch to a smaller number or by using the Filter tab to limit the results. If you set this field to zero, the framework will attempt to fetch all values. You might not want to use the zero value if querying a large database.
Select the records that you want to apply security to and click . The records move over to the second column. From this list you can apply security to one or more of the records.
Select the appropriate records in the second list (usually all) and select the action you want to perform. See Table 13–3 for an explanation of your options. The framework sets flags, but their actual meanings depend entirely on your programming. Table 13–3 provides an example of what your code might do in these cases.

Table 13–3: Data security by security model 

Model	Action	Intended effect
Revoke	Revoke access	Prevents the specified users from accessing the selected records.
Revoke	Not secured	Removes any existing data security for the specified users on the selected records.
Grant	Grant access	Allows the specified users to access the selected records.
Grant	No access	Prevents the specified users from accessing the selected records throughout the application.

Click Apply.
Click the Save button at the top of the panel to save the allocations.